{% extends "base.html" %}


{% block  title %}数据库信息{% endblock %}

{% block page-content %}


    <div class="row wrapper border-bottom white-bg page-heading">
        <div class="col-lg-10">
            <h2>数据库用户信息</h2>
            <ol class="breadcrumb">
                <li>
                    <a href="/index.html">主页</a>
                </li>
                <li>
                    <a href="/db/db-user.html">数据库用户管理</a>
                </li>
                <li class="active">
                    <strong>数据库用户信息</strong>
                </li>
            </ol>
        </div>
        <div class="col-lg-2">

        </div>
    </div>
    <div class="wrapper wrapper-content animated fadeInRight">
        <div class="row">
            <div class="col-lg-12">
                <div class="ibox float-e-margins">
                    <div class="ibox-title">
                        <h5>数据库用户信息</h5>
                        <div class="ibox-tools">
                            <a class="collapse-link">
                                <i class="fa fa-chevron-up"></i>
                            </a>
                            <a class="dropdown-toggle" data-toggle="dropdown" href="#">
                                <i class="fa fa-wrench"></i>
                            </a>
                            <ul class="dropdown-menu dropdown-user">
                                <li><a href="#">选项 1</a>
                                </li>
                                <li><a href="#">选项 2</a>
                                </li>
                            </ul>
                            <a class="close-link">
                                <i class="fa fa-times"></i>
                            </a>
                        </div>
                    </div>
                    <div class="ibox-content">

                        <div class="table-responsive">

                            <a href="{% url    'db:db_user_add' %}" class="btn btn-primary  ">
                                添加</a>

                            <table class="table table-striped table-bordered table-hover dataTables-example">
                                <thead>
                                <tr>
                                    <th>名称</th>
                                    <th>系统用户</th>
                                     <th>产品线</th>
                                    <th>备注</th>
                                    <th>动作</th>
                                </tr>
                                </thead>
                                <tbody>

                                {% for   row   in  db_user_list %}
                                    <tr class="gradeA" id="{{ row.id }}">
                                        <td class="center"><a  href="{% url  "db:db_user_detail"   pk=row.id %}">  {{ row.name }}</a>
                                        </td>
                                        <td class="center">{{ row.username }}</td>
                                        <td class="center">{{ row.product_line }}</td>
                                        <td class="center">{{ row.ps }}</td>
                                        <td><a class="btn btn-primary  btn-xs"
                                               href="{% url  "db:db_user_update"   row.id %}" >编辑</a>
                                            <button class="btn btn-danger  btn-xs  db_user_del"

                                                    >删除
                                            </button>
                                        </td>
                                    </tr>
                                {% endfor %}

                                </tbody>
                                <tfoot>
                                <tr>
                                    <th>名称</th>
                                    <th>系统用户</th>
                                     <th>产品线</th>
                                    <th>备注</th>
                                    <th>动作</th>
                                </tr>
                                </tfoot>
                            </table>
                        </div>

                    </div>
                </div>
            </div>
        </div>
    </div>




    {% block footer-js %}

              <script type="text/JavaScript">
    $.ajaxSetup({headers: {"X-CSRFToken": '{{ csrf_token }}'}});
</script>


        <script>
            $(function () {

                $('.db_user_del').click(function () {
                    var id = $(this).parent().parent().attr('id');

                        swal({

                        title: "你确定删除",
                        text: "你将无法恢复",
                        type: "warning",
                        showCancelButton: true,
                        confirmButtonColor: "#DD6B55",
                        confirmButtonText: "确定",

                        closeOnConfirm: false
                    }, function () {


                    $.ajax({
                        url: "/db/db-user-del.html",
                        type: 'POST',
                       data: {'nid': id},
                            success: function (data) {
                                var obj = JSON.parse(data);
                                if (obj.status) {
                                    swal({title: "删除", text: "已成功删除", type: "success"}, function () {
                                        window.location.reload();
                                    })
                                } else {
                                    swal("错误", "删除" + "[ " + obj.error + " ]" + "遇到错误", "error");
                                }
                        }
                    })
                });
 });

            });
        </script>


    {% endblock %}

{% endblock %}